UCSF

Parameters Provided:

name.synonym = 1-Myristoyl-glycero-3-phosphocholine; LPC(14:0); LPC(14:0/0:0); LyPC(14:0); LyPC(14:0/0:0); LysoPC(14:0); LysoPC(14:0/0:0); Lysophosphatidylcholine(14:0); Lysophosphatidylcholine(14:0/0:0); lysoPC a C14:0
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-Myristoyl-glycero-3-phosphocholine; LPC(14:0); LPC(14:0/0:0); LyPC(14:0); LyPC(14:0/0:0); LysoPC(14:0); LysoPC(14:0/0:0); Lysophosphatidylcholine(14:0); Lysophosphatidylcholine(14:0/0:0); lysoPC a C14:0' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-Myristoyl-glycero-3-phosphocholine%3B+LPC%2814%3A0%29%3B+LPC%2814%3A0%2F0%3A0%29%3B+LyPC%2814%3A0%29%3B+LyPC%2814%3A0%2F0%3A0%29%3B+LysoPC%2814%3A0%29%3B+LysoPC%2814%3A0%2F0%3A0%29%3B+Lysophosphatidylcholine%2814%3A0%29%3B+Lysophosphatidylcholine%2814%3A0%2F0%3A0%29%3B+lysoPC+a+C14%3A0&filter.purchasability=all

Embed Link to Results